Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 26792 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.7 MiB |
| Average record size in memory | 105.0 B |
Variable types
| Categorical | 1 |
|---|---|
| Numeric | 10 |
| Boolean | 1 |
| DateTime | 1 |
Year has constant value "2019" | Constant |
is_day has constant value "True" | Constant |
DHI is highly overall correlated with GHI and 1 other fields | High correlation |
DNI is highly overall correlated with GHI and 1 other fields | High correlation |
GHI is highly overall correlated with DHI and 2 other fields | High correlation |
Relative Humidity is highly overall correlated with Temperature | High correlation |
Solar Zenith Angle is highly overall correlated with DHI and 2 other fields | High correlation |
Temperature is highly overall correlated with Relative Humidity | High correlation |
Datetime has unique values | Unique |
Minute has 4471 (16.7%) zeros | Zeros |
DHI has 1881 (7.0%) zeros | Zeros |
DNI has 3437 (12.8%) zeros | Zeros |
GHI has 1881 (7.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-11-05 06:56:43.334446 |
|---|---|
| Analysis finished | 2023-11-05 06:57:03.389631 |
| Duration | 20.06 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
Year
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| 2019 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 107168 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2019 |
|---|---|
| 2nd row | 2019 |
| 3rd row | 2019 |
| 4th row | 2019 |
| 5th row | 2019 |
Common Values
| Value | Count | Frequency (%) |
| 2019 | 26792 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2019 | 26792 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 26792 | |
| 0 | 26792 | |
| 1 | 26792 | |
| 9 | 26792 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 107168 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 26792 | |
| 0 | 26792 | |
| 1 | 26792 | |
| 9 | 26792 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 107168 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 26792 | |
| 0 | 26792 | |
| 1 | 26792 | |
| 9 | 26792 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 107168 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 26792 | |
| 0 | 26792 | |
| 1 | 26792 | |
| 9 | 26792 |
Month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.4575246 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 418.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.2399911 |
|---|---|
| Coefficient of variation (CV) | 0.50173887 |
| Kurtosis | -1.0527107 |
| Mean | 6.4575246 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.023194774 |
| Sum | 173010 |
| Variance | 10.497543 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 7 | 2678 | |
| 5 | 2633 | |
| 6 | 2628 | |
| 8 | 2520 | |
| 4 | 2371 | |
| 3 | 2239 | |
| 9 | 2239 | |
| 10 | 2103 | |
| 1 | 1869 | |
| 11 | 1854 | |
| Other values (2) | 3658 |
| Value | Count | Frequency (%) |
| 1 | 1869 | |
| 2 | 1837 | |
| 3 | 2239 | |
| 4 | 2371 | |
| 5 | 2633 | |
| 6 | 2628 | |
| 7 | 2678 | |
| 8 | 2520 | |
| 9 | 2239 | |
| 10 | 2103 |
| Value | Count | Frequency (%) |
| 12 | 1821 | |
| 11 | 1854 | |
| 10 | 2103 | |
| 9 | 2239 | |
| 8 | 2520 | |
| 7 | 2678 | |
| 6 | 2628 | |
| 5 | 2633 | |
| 4 | 2371 | |
| 3 | 2239 |
Day
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.728202 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 418.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7977341 |
|---|---|
| Coefficient of variation (CV) | 0.55936043 |
| Kurtosis | -1.1939322 |
| Mean | 15.728202 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.0063629486 |
| Sum | 421390 |
| Variance | 77.400126 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 883 | 3.3% |
| 28 | 883 | 3.3% |
| 22 | 882 | 3.3% |
| 23 | 882 | 3.3% |
| 21 | 882 | 3.3% |
| 7 | 882 | 3.3% |
| 17 | 882 | 3.3% |
| 19 | 881 | 3.3% |
| 18 | 881 | 3.3% |
| 24 | 881 | 3.3% |
| Other values (21) | 17973 |
| Value | Count | Frequency (%) |
| 1 | 879 | |
| 2 | 879 | |
| 3 | 880 | |
| 4 | 881 | |
| 5 | 883 | |
| 6 | 881 | |
| 7 | 882 | |
| 8 | 881 | |
| 9 | 879 | |
| 10 | 878 |
| Value | Count | Frequency (%) |
| 31 | 510 | |
| 30 | 811 | |
| 29 | 814 | |
| 28 | 883 | |
| 27 | 881 | |
| 26 | 880 | |
| 25 | 881 | |
| 24 | 881 | |
| 23 | 882 | |
| 22 | 882 |
Hour
Real number (ℝ)
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.969655 |
| Minimum | 5 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 418.6 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 9 |
| median | 12 |
| Q3 | 15 |
| 95-th percentile | 18 |
| Maximum | 20 |
| Range | 15 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.6722624 |
|---|---|
| Coefficient of variation (CV) | 0.30679768 |
| Kurtosis | -1.0487346 |
| Mean | 11.969655 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.075828131 |
| Sum | 320691 |
| Variance | 13.485511 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 2190 | |
| 9 | 2190 | |
| 10 | 2190 | |
| 11 | 2190 | |
| 12 | 2190 | |
| 13 | 2190 | |
| 14 | 2190 | |
| 15 | 2190 | |
| 7 | 2186 | |
| 16 | 2034 | |
| Other values (6) | 5052 |
| Value | Count | Frequency (%) |
| 5 | 230 | 0.9% |
| 6 | 1316 | |
| 7 | 2186 | |
| 8 | 2190 | |
| 9 | 2190 | |
| 10 | 2190 | |
| 11 | 2190 | |
| 12 | 2190 | |
| 13 | 2190 | |
| 14 | 2190 |
| Value | Count | Frequency (%) |
| 20 | 31 | 0.1% |
| 19 | 696 | 2.6% |
| 18 | 1232 | |
| 17 | 1547 | |
| 16 | 2034 | |
| 15 | 2190 | |
| 14 | 2190 | |
| 13 | 2190 | |
| 12 | 2190 | |
| 11 | 2190 |
Minute
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.040311 |
| Minimum | 0 |
|---|---|
| Maximum | 50 |
| Zeros | 4471 |
| Zeros (%) | 16.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 418.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10 |
| median | 30 |
| Q3 | 40 |
| 95-th percentile | 50 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 17.094761 |
|---|---|
| Coefficient of variation (CV) | 0.68268964 |
| Kurtosis | -1.270323 |
| Mean | 25.040311 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | -0.0040708679 |
| Sum | 670880 |
| Variance | 292.23084 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 4490 | |
| 30 | 4474 | |
| 40 | 4472 | |
| 0 | 4471 | |
| 20 | 4443 | |
| 10 | 4442 |
| Value | Count | Frequency (%) |
| 0 | 4471 | |
| 10 | 4442 | |
| 20 | 4443 | |
| 30 | 4474 | |
| 40 | 4472 | |
| 50 | 4490 |
| Value | Count | Frequency (%) |
| 50 | 4490 | |
| 40 | 4472 | |
| 30 | 4474 | |
| 20 | 4443 | |
| 10 | 4442 | |
| 0 | 4471 |
DHI
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 495 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 99.262504 |
| Minimum | 0 |
|---|---|
| Maximum | 499 |
| Zeros | 1881 |
| Zeros (%) | 7.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 418.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 56 |
| median | 82 |
| Q3 | 111 |
| 95-th percentile | 285 |
| Maximum | 499 |
| Range | 499 |
| Interquartile range (IQR) | 55 |
Descriptive statistics
| Standard deviation | 82.428428 |
|---|---|
| Coefficient of variation (CV) | 0.83040851 |
| Kurtosis | 4.8731611 |
| Mean | 99.262504 |
| Median Absolute Deviation (MAD) | 28 |
| Skewness | 2.0071733 |
| Sum | 2659441 |
| Variance | 6794.4458 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1881 | 7.0% |
| 68 | 300 | 1.1% |
| 72 | 292 | 1.1% |
| 76 | 289 | 1.1% |
| 73 | 288 | 1.1% |
| 93 | 286 | 1.1% |
| 66 | 285 | 1.1% |
| 77 | 283 | 1.1% |
| 74 | 281 | 1.0% |
| 75 | 280 | 1.0% |
| Other values (485) | 22327 |
| Value | Count | Frequency (%) |
| 0 | 1881 | |
| 3 | 6 | < 0.1% |
| 4 | 20 | 0.1% |
| 5 | 26 | 0.1% |
| 6 | 43 | 0.2% |
| 7 | 41 | 0.2% |
| 8 | 35 | 0.1% |
| 9 | 30 | 0.1% |
| 10 | 40 | 0.1% |
| 11 | 75 | 0.3% |
| Value | Count | Frequency (%) |
| 499 | 2 | < 0.1% |
| 498 | 3 | |
| 497 | 2 | < 0.1% |
| 494 | 3 | |
| 493 | 3 | |
| 492 | 4 | |
| 491 | 3 | |
| 490 | 1 | < 0.1% |
| 489 | 1 | < 0.1% |
| 488 | 5 |
DNI
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 1038 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 601.02079 |
| Minimum | 0 |
|---|---|
| Maximum | 1037 |
| Zeros | 3437 |
| Zeros (%) | 12.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 418.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 276 |
| median | 753 |
| Q3 | 906 |
| 95-th percentile | 971 |
| Maximum | 1037 |
| Range | 1037 |
| Interquartile range (IQR) | 630 |
Descriptive statistics
| Standard deviation | 354.88275 |
|---|---|
| Coefficient of variation (CV) | 0.59046669 |
| Kurtosis | -1.159793 |
| Mean | 601.02079 |
| Median Absolute Deviation (MAD) | 191 |
| Skewness | -0.63886 |
| Sum | 16102549 |
| Variance | 125941.77 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3437 | 12.8% |
| 946 | 110 | 0.4% |
| 934 | 99 | 0.4% |
| 953 | 97 | 0.4% |
| 941 | 96 | 0.4% |
| 944 | 95 | 0.4% |
| 956 | 95 | 0.4% |
| 942 | 94 | 0.4% |
| 900 | 94 | 0.4% |
| 935 | 93 | 0.3% |
| Other values (1028) | 22482 |
| Value | Count | Frequency (%) |
| 0 | 3437 | |
| 1 | 17 | 0.1% |
| 2 | 25 | 0.1% |
| 3 | 24 | 0.1% |
| 4 | 20 | 0.1% |
| 5 | 13 | < 0.1% |
| 6 | 21 | 0.1% |
| 7 | 20 | 0.1% |
| 8 | 16 | 0.1% |
| 9 | 21 | 0.1% |
| Value | Count | Frequency (%) |
| 1037 | 1 | < 0.1% |
| 1036 | 4 | |
| 1035 | 2 | < 0.1% |
| 1034 | 2 | < 0.1% |
| 1033 | 2 | < 0.1% |
| 1032 | 1 | < 0.1% |
| 1031 | 2 | < 0.1% |
| 1030 | 2 | < 0.1% |
| 1029 | 1 | < 0.1% |
| 1028 | 6 |
GHI
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 1062 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 455.09533 |
| Minimum | 0 |
|---|---|
| Maximum | 1063 |
| Zeros | 1881 |
| Zeros (%) | 7.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 418.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 172 |
| median | 446 |
| Q3 | 718 |
| 95-th percentile | 968 |
| Maximum | 1063 |
| Range | 1063 |
| Interquartile range (IQR) | 546 |
Descriptive statistics
| Standard deviation | 314.09852 |
|---|---|
| Coefficient of variation (CV) | 0.69018183 |
| Kurtosis | -1.2023298 |
| Mean | 455.09533 |
| Median Absolute Deviation (MAD) | 273 |
| Skewness | 0.12601269 |
| Sum | 12192914 |
| Variance | 98657.883 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1881 | 7.0% |
| 15 | 70 | 0.3% |
| 42 | 53 | 0.2% |
| 17 | 50 | 0.2% |
| 33 | 50 | 0.2% |
| 14 | 49 | 0.2% |
| 18 | 49 | 0.2% |
| 26 | 48 | 0.2% |
| 13 | 48 | 0.2% |
| 31 | 47 | 0.2% |
| Other values (1052) | 24447 |
| Value | Count | Frequency (%) |
| 0 | 1881 | |
| 3 | 6 | < 0.1% |
| 4 | 20 | 0.1% |
| 5 | 26 | 0.1% |
| 6 | 43 | 0.2% |
| 7 | 41 | 0.2% |
| 8 | 35 | 0.1% |
| 9 | 28 | 0.1% |
| 10 | 33 | 0.1% |
| 11 | 38 | 0.1% |
| Value | Count | Frequency (%) |
| 1063 | 3 | |
| 1062 | 3 | |
| 1061 | 2 | < 0.1% |
| 1060 | 4 | |
| 1059 | 3 | |
| 1058 | 4 | |
| 1057 | 2 | < 0.1% |
| 1056 | 7 | |
| 1055 | 2 | < 0.1% |
| 1054 | 4 |
Relative Humidity
Real number (ℝ)
| Distinct | 5818 |
|---|---|
| Distinct (%) | 21.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.742811 |
| Minimum | 3.16 |
|---|---|
| Maximum | 92.14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 418.6 KiB |
Quantile statistics
| Minimum | 3.16 |
|---|---|
| 5-th percentile | 6.28 |
| Q1 | 11.53 |
| median | 18.74 |
| Q3 | 31.9925 |
| 95-th percentile | 57.149 |
| Maximum | 92.14 |
| Range | 88.98 |
| Interquartile range (IQR) | 20.4625 |
Descriptive statistics
| Standard deviation | 16.290496 |
|---|---|
| Coefficient of variation (CV) | 0.68612329 |
| Kurtosis | 1.3702742 |
| Mean | 23.742811 |
| Median Absolute Deviation (MAD) | 8.96 |
| Skewness | 1.276409 |
| Sum | 636117.4 |
| Variance | 265.38026 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14.83 | 30 | 0.1% |
| 8.42 | 28 | 0.1% |
| 6.73 | 27 | 0.1% |
| 14.57 | 25 | 0.1% |
| 7.56 | 24 | 0.1% |
| 8.98 | 23 | 0.1% |
| 7.45 | 23 | 0.1% |
| 12.18 | 23 | 0.1% |
| 19.91 | 23 | 0.1% |
| 8.91 | 23 | 0.1% |
| Other values (5808) | 26543 |
| Value | Count | Frequency (%) |
| 3.16 | 1 | < 0.1% |
| 3.19 | 4 | |
| 3.21 | 2 | < 0.1% |
| 3.23 | 2 | < 0.1% |
| 3.25 | 4 | |
| 3.26 | 1 | < 0.1% |
| 3.27 | 3 | |
| 3.28 | 1 | < 0.1% |
| 3.29 | 7 | |
| 3.31 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 92.14 | 1 | |
| 91.51 | 1 | |
| 91.15 | 1 | |
| 90.27 | 1 | |
| 90.02 | 1 | |
| 89.61 | 1 | |
| 89.44 | 2 | |
| 89 | 1 | |
| 88.83 | 1 | |
| 88.32 | 1 |
Solar Zenith Angle
Real number (ℝ)
| Distinct | 8140 |
|---|---|
| Distinct (%) | 30.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58.389402 |
| Minimum | 12.73 |
|---|---|
| Maximum | 103.23 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 418.6 KiB |
Quantile statistics
| Minimum | 12.73 |
|---|---|
| 5-th percentile | 21.4855 |
| Q1 | 43.26 |
| median | 59.54 |
| Q3 | 73.97 |
| 95-th percentile | 91.87 |
| Maximum | 103.23 |
| Range | 90.5 |
| Interquartile range (IQR) | 30.71 |
Descriptive statistics
| Standard deviation | 21.029689 |
|---|---|
| Coefficient of variation (CV) | 0.36016278 |
| Kurtosis | -0.68573604 |
| Mean | 58.389402 |
| Median Absolute Deviation (MAD) | 15.23 |
| Skewness | -0.13698239 |
| Sum | 1564368.9 |
| Variance | 442.24783 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.12 | 16 | 0.1% |
| 59.61 | 14 | 0.1% |
| 62.13 | 13 | < 0.1% |
| 60.07 | 13 | < 0.1% |
| 59.03 | 13 | < 0.1% |
| 54.29 | 13 | < 0.1% |
| 56.04 | 13 | < 0.1% |
| 59.25 | 13 | < 0.1% |
| 49.74 | 12 | < 0.1% |
| 58.04 | 12 | < 0.1% |
| Other values (8130) | 26660 |
| Value | Count | Frequency (%) |
| 12.73 | 2 | |
| 12.74 | 2 | |
| 12.75 | 1 | < 0.1% |
| 12.76 | 1 | < 0.1% |
| 12.77 | 1 | < 0.1% |
| 12.78 | 1 | < 0.1% |
| 12.8 | 1 | < 0.1% |
| 12.81 | 1 | < 0.1% |
| 12.83 | 3 | |
| 12.84 | 4 |
| Value | Count | Frequency (%) |
| 103.23 | 1 | |
| 103.19 | 1 | |
| 103.15 | 1 | |
| 103.07 | 1 | |
| 103 | 1 | |
| 102.96 | 1 | |
| 102.95 | 1 | |
| 102.94 | 1 | |
| 102.92 | 2 | |
| 102.89 | 2 |
Temperature
Real number (ℝ)
| Distinct | 453 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.550657 |
| Minimum | -1.1 |
|---|---|
| Maximum | 44.9 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 5 |
| Negative (%) | < 0.1% |
| Memory size | 418.6 KiB |
Quantile statistics
| Minimum | -1.1 |
|---|---|
| 5-th percentile | 7.6 |
| Q1 | 15.7 |
| median | 24.6 |
| Q3 | 33.6 |
| 95-th percentile | 41.1 |
| Maximum | 44.9 |
| Range | 46 |
| Interquartile range (IQR) | 17.9 |
Descriptive statistics
| Standard deviation | 10.715733 |
|---|---|
| Coefficient of variation (CV) | 0.43647438 |
| Kurtosis | -1.0676748 |
| Mean | 24.550657 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | -0.05373519 |
| Sum | 657761.2 |
| Variance | 114.82693 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 26.2 | 117 | 0.4% |
| 32.3 | 113 | 0.4% |
| 26.5 | 104 | 0.4% |
| 22.3 | 104 | 0.4% |
| 26.7 | 102 | 0.4% |
| 24.4 | 101 | 0.4% |
| 31.1 | 100 | 0.4% |
| 25.3 | 98 | 0.4% |
| 25.9 | 97 | 0.4% |
| 24.1 | 97 | 0.4% |
| Other values (443) | 25759 |
| Value | Count | Frequency (%) |
| -1.1 | 1 | < 0.1% |
| -0.7 | 1 | < 0.1% |
| -0.4 | 2 | |
| -0.1 | 1 | < 0.1% |
| 0 | 1 | < 0.1% |
| 0.1 | 1 | < 0.1% |
| 0.2 | 2 | |
| 0.3 | 2 | |
| 0.5 | 4 | |
| 0.6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 44.9 | 6 | < 0.1% |
| 44.8 | 5 | < 0.1% |
| 44.7 | 3 | < 0.1% |
| 44.6 | 5 | < 0.1% |
| 44.5 | 6 | < 0.1% |
| 44.4 | 6 | < 0.1% |
| 44.3 | 8 | < 0.1% |
| 44.2 | 22 | |
| 44.1 | 10 | |
| 44 | 13 |
is_day
Boolean
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 235.5 KiB |
| True |
|---|
| Value | Count | Frequency (%) |
| True | 26792 |
Datetime
Date
| Distinct | 26792 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 418.6 KiB |
| Minimum | 2019-01-01 07:00:00 |
|---|---|
| Maximum | 2019-12-31 16:30:00 |
| Month | Day | Hour | Minute | DHI | DNI | GHI | Relative Humidity | Solar Zenith Angle | Temperature | |
|---|---|---|---|---|---|---|---|---|---|---|
| Month | 1.000 | -0.006 | -0.019 | -0.001 | -0.141 | 0.090 | -0.002 | -0.359 | 0.055 | 0.246 |
| Day | -0.006 | 1.000 | 0.006 | 0.001 | 0.000 | -0.006 | -0.007 | 0.054 | 0.000 | -0.034 |
| Hour | -0.019 | 0.006 | 1.000 | -0.074 | -0.236 | -0.285 | -0.293 | -0.155 | 0.274 | 0.154 |
| Minute | -0.001 | 0.001 | -0.074 | 1.000 | -0.003 | -0.002 | -0.002 | -0.003 | 0.004 | 0.004 |
| DHI | -0.141 | 0.000 | -0.236 | -0.003 | 1.000 | 0.248 | 0.665 | -0.129 | -0.788 | 0.279 |
| DNI | 0.090 | -0.006 | -0.285 | -0.002 | 0.248 | 1.000 | 0.834 | -0.483 | -0.627 | 0.270 |
| GHI | -0.002 | -0.007 | -0.293 | -0.002 | 0.665 | 0.834 | 1.000 | -0.472 | -0.922 | 0.459 |
| Relative Humidity | -0.359 | 0.054 | -0.155 | -0.003 | -0.129 | -0.483 | -0.472 | 1.000 | 0.383 | -0.736 |
| Solar Zenith Angle | 0.055 | 0.000 | 0.274 | 0.004 | -0.788 | -0.627 | -0.922 | 0.383 | 1.000 | -0.461 |
| Temperature | 0.246 | -0.034 | 0.154 | 0.004 | 0.279 | 0.270 | 0.459 | -0.736 | -0.461 | 1.000 |
| Year | Month | Day | Hour | Minute | DHI | DNI | GHI | Relative Humidity | Solar Zenith Angle | Temperature | is_day | Datetime | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42 | 2019 | 1 | 1 | 7 | 0 | 11 | 245 | 15 | 30.49 | 88.97 | -0.4 | True | 2019-01-01 07:00:00 |
| 43 | 2019 | 1 | 1 | 7 | 10 | 17 | 375 | 34 | 29.84 | 87.36 | -0.1 | True | 2019-01-01 07:10:00 |
| 44 | 2019 | 1 | 1 | 7 | 20 | 22 | 475 | 58 | 29.19 | 85.72 | 0.2 | True | 2019-01-01 07:20:00 |
| 45 | 2019 | 1 | 1 | 7 | 30 | 27 | 555 | 85 | 28.60 | 84.07 | 0.5 | True | 2019-01-01 07:30:00 |
| 46 | 2019 | 1 | 1 | 7 | 40 | 32 | 620 | 113 | 25.91 | 82.44 | 0.9 | True | 2019-01-01 07:40:00 |
| 47 | 2019 | 1 | 1 | 7 | 50 | 35 | 673 | 143 | 25.36 | 80.84 | 1.2 | True | 2019-01-01 07:50:00 |
| 48 | 2019 | 1 | 1 | 8 | 0 | 39 | 717 | 172 | 24.82 | 79.26 | 1.5 | True | 2019-01-01 08:00:00 |
| 49 | 2019 | 1 | 1 | 8 | 10 | 42 | 755 | 202 | 24.29 | 77.73 | 1.8 | True | 2019-01-01 08:10:00 |
| 50 | 2019 | 1 | 1 | 8 | 20 | 44 | 787 | 232 | 23.95 | 76.22 | 2.0 | True | 2019-01-01 08:20:00 |
| 51 | 2019 | 1 | 1 | 8 | 30 | 47 | 814 | 261 | 23.61 | 74.77 | 2.2 | True | 2019-01-01 08:30:00 |
| Year | Month | Day | Hour | Minute | DHI | DNI | GHI | Relative Humidity | Solar Zenith Angle | Temperature | is_day | Datetime | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52506 | 2019 | 12 | 31 | 15 | 0 | 42 | 798 | 247 | 37.81 | 75.15 | 10.2 | True | 2019-12-31 15:00:00 |
| 52507 | 2019 | 12 | 31 | 15 | 10 | 40 | 770 | 219 | 37.81 | 76.61 | 10.2 | True | 2019-12-31 15:10:00 |
| 52508 | 2019 | 12 | 31 | 15 | 20 | 38 | 737 | 190 | 37.81 | 78.12 | 10.2 | True | 2019-12-31 15:20:00 |
| 52509 | 2019 | 12 | 31 | 15 | 30 | 35 | 699 | 161 | 37.81 | 79.67 | 10.2 | True | 2019-12-31 15:30:00 |
| 52510 | 2019 | 12 | 31 | 15 | 40 | 32 | 654 | 132 | 37.81 | 81.25 | 10.2 | True | 2019-12-31 15:40:00 |
| 52511 | 2019 | 12 | 31 | 15 | 50 | 29 | 600 | 103 | 37.81 | 82.85 | 10.2 | True | 2019-12-31 15:50:00 |
| 52512 | 2019 | 12 | 31 | 16 | 0 | 33 | 2 | 33 | 30.41 | 84.45 | 4.4 | True | 2019-12-31 16:00:00 |
| 52513 | 2019 | 12 | 31 | 16 | 10 | 24 | 4 | 24 | 31.05 | 86.10 | 4.1 | True | 2019-12-31 16:10:00 |
| 52514 | 2019 | 12 | 31 | 16 | 20 | 12 | 0 | 12 | 31.71 | 87.74 | 3.8 | True | 2019-12-31 16:20:00 |
| 52515 | 2019 | 12 | 31 | 16 | 30 | 0 | 0 | 0 | 32.16 | 89.33 | 3.6 | True | 2019-12-31 16:30:00 |